<?php
require_once 'CRUD/Properties.php';

/*
     ###############################################
     ####                                       ####
     ####    Author : Harish Chauhan            ####
     ####    Date   : 31 Dec,2004               ####
     ####    Updated:                           ####
     ####                                       ####
     ###############################################

     */


/**
 * Class is used for save the data into microsoft excel format.
 * It takes data into array or you can write data column vise.
 */


class ExcelWriter extends Properties {
	
	/**
	 * @var mixed
	 */
	private $fp = null;

	/**
	 * @var string
	 */
	private $error;

	/**
	 * @var string
	 */
	private $state = "CLOSED";

	/**
	 * @var boolean
	 */
	private $newRow = false;

	/**
	 * @Params : $file  : file name of excel file to be created.
	 * @Return : On Success Valid File Pointer to file
	 * 			On Failure return false	 
	 */
	
	public function __construct($file = "") {
		return $this->open($file);
	}

	/**
	 * @Params : $file  : file name of excel file to be created.
	 * 			if you are using file name with directory i.e. test/myFile.xls
	 * 			then the directory must be existed on the system and have permissioned properly
	 * 			to write the file.
	 * @Return : On Success Valid File Pointer to file
	 * 			On Failure return false	 
	 */
	public function open($file) {
		if($this->state != "CLOSED") {
			$this->error = "Error : Another file is opend .Close it to save the file";
			return false;
		}
		
		if(! empty($file)) {
			$this->fp = @fopen($file, "w+");
		} else {
			$this->error = "Usage : New ExcelWriter('fileName')";
			return false;
		}
		if($this->fp == false) {
			$this->error = "Error: Unable to open/create File.You may not have permmsion to write the file.";
			return false;
		}
		$this->state = "OPENED";
		fwrite($this->fp, $this->getHeader());
		return $this->fp;
	}

	public function close() {
		if($this->state != "OPENED") {
			$this->error = "Error : Please open the file.";
			return false;
		}
		if($this->newRow) {
			fwrite($this->fp, "</tr>");
			$this->newRow = false;
		}
		
		fwrite($this->fp, $this->getFooter());
		fclose($this->fp);
		$this->state = "CLOSED";
		return true;
	}

	/** @Params : Void
	 *  @return : Void
	 * This public function write the header of Excel file.
	 */
	
	public function getHeader() {
		$header = <<<EOH
				<html xmlns:o="urn:schemas-microsoft-com:office:office"
				xmlns:x="urn:schemas-microsoft-com:office:excel"
				xmlns="http://www.w3.org/TR/REC-html40">

				<head>
				<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
				<meta name=ProgId content=Excel.Sheet>
				<!--[if gte mso 9]><xml>
				 <o:DocumentProperties>
				  <o:LastAuthor>Sriram</o:LastAuthor>
				  <o:LastSaved>2005-01-02T07:46:23Z</o:LastSaved>
				  <o:Version>10.2625</o:Version>
				 </o:DocumentProperties>
				 <o:OfficeDocumentSettings>
				  <o:DownloadComponents/>
				 </o:OfficeDocumentSettings>
				</xml><![endif]-->
				<style>
				<!--table
					{mso-displayed-decimal-separator:"\.";
					mso-displayed-thousand-separator:"\,";}
				@page
					{margin:1.0in .75in 1.0in .75in;
					mso-header-margin:.5in;
					mso-footer-margin:.5in;}
				tr
					{mso-height-source:auto;}
				col
					{mso-width-source:auto;}
				br
					{mso-data-placement:same-cell;}
				.style0
					{mso-number-format:General;
					text-align:general;
					vertical-align:bottom;
					white-space:nowrap;
					mso-rotate:0;
					mso-background-source:auto;
					mso-pattern:auto;
					color:windowtext;
					font-size:10.0pt;
					font-weight:400;
					font-style:normal;
					text-decoration:none;
					font-family:Arial;
					mso-generic-font-family:auto;
					mso-font-charset:0;
					border:none;
					mso-protection:locked visible;
					mso-style-name:Normal;
					mso-style-id:0;}
				td
					{mso-style-parent:style0;
					padding-top:1px;
					padding-right:1px;
					padding-left:1px;
					mso-ignore:padding;
					color:windowtext;
					font-size:10.0pt;
					font-weight:400;
					font-style:normal;
					text-decoration:none;
					font-family:Arial,Vedana;
					mso-generic-font-family:auto;
					mso-font-charset:0;
					mso-number-format:General;
					text-align:general;
					vertical-align:bottom;
					border:none;
					mso-background-source:auto;
					mso-pattern:auto;
					mso-protection:locked visible;
					white-space:nowrap;
					mso-rotate:0;}
				.xl24
					{mso-style-parent:style0;
					white-space:normal;}
				-->
				</style>
				<!--[if gte mso 9]><xml>
				 <x:ExcelWorkbook>
				  <x:ExcelWorksheets>
				   <x:ExcelWorksheet>
					<x:Name>srirmam</x:Name>
					<x:WorksheetOptions>
					 <x:Selected/>
					 <x:ProtectContents>False</x:ProtectContents>
					 <x:ProtectObjects>False</x:ProtectObjects>
					 <x:ProtectScenarios>False</x:ProtectScenarios>
					</x:WorksheetOptions>
				   </x:ExcelWorksheet>
				  </x:ExcelWorksheets>
				  <x:WindowHeight>10005</x:WindowHeight>
				  <x:WindowWidth>10005</x:WindowWidth>
				  <x:WindowTopX>120</x:WindowTopX>
				  <x:WindowTopY>135</x:WindowTopY>
				  <x:ProtectStructure>False</x:ProtectStructure>
				  <x:ProtectWindows>False</x:ProtectWindows>
				 </x:ExcelWorkbook>
				</xml><![endif]-->
				</head>

				<body link=blue vlink=purple>
				<table x:str border=0 cellpadding=0 cellspacing=0 style='border-collapse: collapse;table-layout:fixed;'>
EOH;
		return $header;
	}

	public function getFooter() {
		return "</table></body></html>";
	}

	/**
	 * @Params : $line_arr: An valid array 
	 * @Return : Void
	 */
	
	public function writeLine($line_arr) {
		if($this->state != "OPENED") {
			$this->error = "Error : Please open the file.";
			return false;
		}
		if(! is_array($line_arr)) {
			$this->error = "Error : Argument is not valid. Supply an valid Array.";
			return false;
		}
		fwrite($this->fp, "<tr>");
		foreach($line_arr as $col)
			fwrite($this->fp, "<td class=xl24 width=64 >$col</td>");
		fwrite($this->fp, "</tr>");
	}

	/**
	 * @Params : Void
	 * @Return : Void
	 */
	public function writeRow() {
		if($this->state != "OPENED") {
			$this->error = "Error : Please open the file.";
			return false;
		}
		if($this->newRow == false)
			fwrite($this->fp, "<tr>");
		else
			fwrite($this->fp, "</tr><tr>");
		$this->newRow = true;
	}

	/**
	 * @params : $value : Coloumn Value
	 * @return : Void
	 */
	public function writeCol($value) {
		if($this->state != "OPENED") {
			$this->error = "Error : Please open the file.";
			return false;
		}
		fwrite($this->fp, "<td class=xl24 width=64 >$value</td>");
	}

	
	/**
	 * @return string
	 */
	public function getError() {
		return $this->error;
	}

	/**
	 * @return mixed
	 */
	public function getFp() {
		return $this->fp;
	}

	/**
	 * @return boolean
	 */
	public function getNewRow() {
		return $this->newRow;
	}

	/**
	 * @return string
	 */
	public function getState() {
		return $this->state;
	}

	/**
	 * @param string $error
	 */
	public function setError($error) {
		$this->error = $error;
	}

	/**
	 * @param mixed $fp
	 */
	public function setFp($fp) {
		$this->fp = $fp;
	}

	/**
	 * @param boolean $newRow
	 */
	public function setNewRow($newRow) {
		$this->newRow = $newRow;
	}

	/**
	 * @param string $state
	 */
	public function setState($state) {
		$this->state = $state;
	}
	
	
}
?>